Create member

Inside Designer switch to tab Time dimensions or Standard dimensions:

 

·          Open any dimension

·          Place mouse over Member definitions.

·          Right click

·          Select Create calculate member.

 

 

Create calculate member form will appear.

 

 

Let us create one:

 

·          First select parent member

·          Use Cube Explorer to drag and drop Members                        (In this case we will calculate difference

                                                                                                                     between Canada and Mexico)

·          Write name inside Member name box                                        (Difference)

·          Select OK.

 

To see new member:

 

·          Select Member definitions folder

·          Right click

·          Select Refresh from menu

 

To check what we have done, we will add Difference member in a Member data Column area.